Statistics for Maintenance Modelling: Repairable Systems

# Using Excel's Solver¤

Using the Solver facility (accessed from the Tools menu), if you've typed the expression for
ti + n1-1 nt0(1 - )-1 in B1 and a nominal value for 1 in B2, then:

- the Target Cell for solver should be B1
- select the Value of radio button Equal To 0
- set the By Changing Cells entry to B2

Then click the Solve button. When the Solver Results dialog appears, click the Keep Solver Solution radio button.

Click here to open an Excel spreadsheet with the data from the example and the above expression for you to solve - if this opens in Internet Explorer, click here.

## If the Solver option isn't available:

Click Add-Ins on the Tools menu. In the Add-Ins available list, select the Solver Add-in box, and then click OK.

Close